package com.ruoyi.business.domain;

import java.math.BigDecimal;
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.ruoyi.business.dto.InventoryDto;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;
import lombok.Data;

import javax.persistence.*;
import org.hibernate.annotations.GenericGenerator;

/**
 * DispatchLists对象 DispatchLists
 *
 * @author liutietou
 * @since 1.0 2025-07-19
 */
@Entity
@Table(name = "dispatchlists")
@Data
public class DispatchLists extends BaseEntity {

    private static final long serialVersionUID = 1L;

    /**  */
    @Id
    @Column(name="autoid")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer autoid;

    /**  */
    @Excel(name = "")
    @Column(name="dlid")
    private Integer dlid;

    /**  */
    @Excel(name = "")
    @Column(name="icorid")
    private Integer icorid;

    /**  */
    @Excel(name = "")
    @Column(name="cwhcode")
    private String cwhcode;

    /**  */
    @Excel(name = "")
    @ManyToOne
    @JoinColumn(name = "cinvcode")
    private InventoryDto cinvcode;

    /**  */
    @Excel(name = "")
    @Column(name="iquantity")
    private Long iquantity;

    /**  */
    @Excel(name = "")
    @Column(name="inum")
    private BigDecimal  inum;

    /**  */
    @Excel(name = "")
    @Column(name="iquotedprice")
    private BigDecimal iquotedprice;

    /**  */
    @Excel(name = "")
    @Column(name="iunitprice")
    private BigDecimal iunitprice;

    /**  */
    @Excel(name = "")
    @Column(name="itaxunitprice")
    private BigDecimal itaxunitprice;

    /**  */
    @Excel(name = "")
    @Column(name="imoney")
    private BigDecimal imoney;

    /**  */
    @Excel(name = "")
    @Column(name="itax")
    private BigDecimal itax;

    /**  */
    @Excel(name = "")
    @Column(name="isum")
    private BigDecimal isum;

    /**  */
    @Excel(name = "")
    @Column(name="idiscount")
    private BigDecimal idiscount=BigDecimal.ZERO;

    /**  */
    @Excel(name = "")
    @Column(name="inatunitprice")
    private BigDecimal inatunitprice;

    /**  */
    @Excel(name = "")
    @Column(name="inatmoney")
    private BigDecimal inatmoney;

    /**  */
    @Excel(name = "")
    @Column(name="inattax")
    private BigDecimal inattax;

    /**  */
    @Excel(name = "")
    @Column(name="inatsum")
    private BigDecimal inatsum;

    /**  */
    @Excel(name = "")
    @Column(name="inatdiscount")
    private BigDecimal inatdiscount=BigDecimal.ZERO;

    /**  */
    @Excel(name = "")
    @Column(name="isettlenum")
    private BigDecimal isettlenum =BigDecimal.ZERO;

    /**  */
    @Excel(name = "")
    @Column(name="isettlequantity")
    private BigDecimal isettlequantity =BigDecimal.ZERO;

    /**  */
    @Excel(name = "")
    @Column(name="ibatch")
    private Integer ibatch;

    /**  */
    @Excel(name = "")
    @Column(name="cbatch")
    private String cbatch;

    /**  */
    @Excel(name = "")
    @Column(name="bsettleall")
    private Integer bsettleall=0;

    /**  */
    @Excel(name = "")
    @Column(name="cmemo")
    private String cmemo;

    /**  */
    @Excel(name = "")
    @Column(name="cfree1")
    private String cfree1;

    /**  */
    @Excel(name = "")
    @Column(name="cfree2")
    private String cfree2;

    /**  */
    @Excel(name = "")
    @Column(name="itb")
    private Integer itb =0;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dvdate")
    private Date dvdate;

    /**  */
    @Excel(name = "")
    @Column(name="tbquantity")
    private BigDecimal tbquantity=BigDecimal.ZERO;

    /**  */
    @Excel(name = "")
    @Column(name="tbnum")
    private BigDecimal tbnum;

    /**  */
    @Excel(name = "")
    @Column(name="isosid")
    private Integer isosid;

    /**  */
    @Excel(name = "")
    @Column(name="idlsid")
    private Integer idlsid;

    /**  */
    @Excel(name = "")
    @Column(name="kl")
    private Long kl;

    /**  */
    @Excel(name = "")
    @Column(name="kl2")
    private BigDecimal kl2 =new BigDecimal("100");

    /**  */
    @Excel(name = "")
    @Column(name="cinvname")
    private String cinvname;

    /**  */
    @Excel(name = "")
    @Column(name="itaxrate")
    private Long itaxrate;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine22")
    private String cdefine22;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine23")
    private String cdefine23;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine24")
    private String cdefine24;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine25")
    private String cdefine25;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine26")
    private Long cdefine26;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine27")
    private Long cdefine27;

    /**  */
    @Excel(name = "")
    @Column(name="foutquantity")
    private BigDecimal foutquantity;

    /**  */
    @Excel(name = "")
    @Column(name="foutnum")
    private BigDecimal foutnum;

    /**  */
    @Excel(name = "")
    @Column(name="citemcode")
    private String citemcode;

    /**  */
    @Excel(name = "")
    @Column(name="citem_class")
    private String citemClass;

    /**  */
    @Excel(name = "")
    @Column(name="fsalecost")
    private BigDecimal fsalecost =BigDecimal.ZERO;

    /**  */
    @Excel(name = "")
    @Column(name="fsaleprice")
    private BigDecimal fsaleprice=BigDecimal.ZERO;

    /**  */
    @Excel(name = "")
    @Column(name="cvenabbname")
    private String cvenabbname;

    /**  */
    @Excel(name = "")
    @Column(name="citemname")
    private String citemname;

    /**  */
    @Excel(name = "")
    @Column(name="citem_cname")
    private String citemCname;

    /**  */
    @Excel(name = "")
    @Column(name="cfree3")
    private String cfree3;

    /**  */
    @Excel(name = "")
    @Column(name="cfree4")
    private String cfree4;

    /**  */
    @Excel(name = "")
    @Column(name="cfree5")
    private String cfree5;

    /**  */
    @Excel(name = "")
    @Column(name="cfree6")
    private String cfree6;

    /**  */
    @Excel(name = "")
    @Column(name="cfree7")
    private String cfree7;

    /**  */
    @Excel(name = "")
    @Column(name="cfree8")
    private String cfree8;

    /**  */
    @Excel(name = "")
    @Column(name="cfree9")
    private String cfree9;

    /**  */
    @Excel(name = "")
    @Column(name="cfree10")
    private String cfree10;

    /**  */
    @Excel(name = "")
    @Column(name="bisstqc")
    private Integer bisstqc =0;

    /**  */
    @Excel(name = "")
    @Column(name="iinvexchrate")
    private BigDecimal iinvexchrate;

    /**  */
    @Excel(name = "")
    @Column(name="cunitid")
    private String cunitid;

    /**  */
    @Excel(name = "")
    @Column(name="ccode")
    private String ccode;

    /**  */
    @Excel(name = "")
    @Column(name="iretquantity")
    private BigDecimal iretquantity;

    /**  */
    @Excel(name = "")
    @Column(name="fensettlequan")
    private BigDecimal fensettlequan;

    /**  */
    @Excel(name = "")
    @Column(name="fensettlesum")
    private BigDecimal fensettlesum;

    /**  */
    @Excel(name = "")
    @Column(name="isettleprice")
    private BigDecimal isettleprice;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine28")
    private String cdefine28;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine29")
    private String cdefine29;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine30")
    private String cdefine30;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine31")
    private String cdefine31;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine32")
    private String cdefine32;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine33")
    private String cdefine33;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine34")
    private Integer cdefine34;

    /**  */
    @Excel(name = "")
    @Column(name="cdefine35")
    private Integer cdefine35;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="cdefine36")
    private Date cdefine36;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="cdefine37")
    private Date cdefine37;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dmdate")
    private Date dmdate;

    /**  */
    @Excel(name = "")
    @Column(name="bgsp")
    private Integer bgsp;

    /**  */
    @Excel(name = "")
    @Column(name="cgspstate")
    private String cgspstate;

    /**  */
    @Excel(name = "")
    @Column(name="csocode")
    private String csocode;

    /**  */
    @Excel(name = "")
    @Column(name="ccorcode")
    private String ccorcode;

    /**  */
    @Excel(name = "")
    @Column(name="ippartseqid")
    private Integer ippartseqid;

    /**  */
    @Excel(name = "")
    @Column(name="ippartid")
    private Integer ippartid;

    /**  */
    @Excel(name = "")
    @Column(name="ippartqty")
    private BigDecimal  ippartqty;

    /**  */
    @Excel(name = "")
    @Column(name="ccontractid")
    private String ccontractid;

    /**  */
    @Excel(name = "")
    @Column(name="ccontracttagcode")
    private String ccontracttagcode;

    /**  */
    @Excel(name = "")
    @Column(name="ccontractrowguid")
    private String  ccontractrowguid;

    /**  */
    @Excel(name = "")
    @Column(name="imassdate")
    private Integer imassdate;

    /**  */
    @Excel(name = "")
    @Column(name="cmassunit")
    private Integer cmassunit =0;

    /**  */
    @Excel(name = "")
    @Column(name="bqaneedcheck")
    private Integer bqaneedcheck=0;

    /**  */
    @Excel(name = "")
    @Column(name="bqaurgency")
    private Integer bqaurgency=0;

    /**  */
    @Excel(name = "")
    @Column(name="bqachecking")
    private Integer bqachecking=0;

    /**  */
    @Excel(name = "")
    @Column(name="bqachecked")
    private Integer bqachecked=0;

    /**  */
    @Excel(name = "")
    @Column(name="iqaquantity")
    private Long iqaquantity;

    /**  */
    @Excel(name = "")
    @Column(name="iqanum")
    private Long iqanum;

    /**  */
    @Excel(name = "")
    @Column(name="ccusinvcode")
    private String ccusinvcode;

    /**  */
    @Excel(name = "")
    @Column(name="ccusinvname")
    private String ccusinvname;

    /**  */
    @Excel(name = "")
    @Column(name="fsumsignquantity")
    private BigDecimal fsumsignquantity;

    /**  */
    @Excel(name = "")
    @Column(name="fsumsignnum")
    private BigDecimal fsumsignnum;

    /**  */
    @Excel(name = "")
    @Column(name="cbaccounter")
    private String cbaccounter;

    /**  */
    @Excel(name = "")
    @Column(name="bcosting")
    private Integer bcosting=1;

    /**  */
    @Excel(name = "")
    @Column(name="cordercode")
    private String cordercode;

    /**  */
    @Excel(name = "")
    @Column(name="iorderrowno")
    private Long iorderrowno;

    /**  */
    @Excel(name = "")
    @Column(name="fcusminprice")
    private BigDecimal fcusminprice=BigDecimal.ZERO;

    /**  */
    @Excel(name = "")
    @Column(name="icostquantity")
    private BigDecimal icostquantity;

    /**  */
    @Excel(name = "")
    @Column(name="icostsum")
    private BigDecimal icostsum;

    /**  */
    @Excel(name = "")
    @Column(name="ispecialtype")
    private Integer ispecialtype;

    /**  */
    @Excel(name = "")
    @Column(name="cvmivencode")
    private String cvmivencode;

    /**  */
    @Excel(name = "")
    @Column(name="iexchsum")
    private BigDecimal  iexchsum;

    /**  */
    @Excel(name = "")
    @Column(name="imoneysum")
    private BigDecimal  imoneysum;

    /**  */
    @Excel(name = "")
    @Column(name="irowno")
    private Long irowno;

    /**  */
    @Excel(name = "")
    @Column(name="frettbquantity")
    private BigDecimal frettbquantity;

    /**  */
    @Excel(name = "")
    @Column(name="fretsum")
    private BigDecimal fretsum;

    /**  */
    @Excel(name = "")
    @Column(name="iexpiratdatecalcu")
    private Integer iexpiratdatecalcu=0;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dexpirationdate")
    private Date dexpirationdate;

    /**  */
    @Excel(name = "")
    @Column(name="cexpirationdate")
    private String cexpirationdate;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty1")
    private BigDecimal cbatchproperty1;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty2")
    private BigDecimal cbatchproperty2;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty3")
    private BigDecimal cbatchproperty3;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty4")
    private BigDecimal cbatchproperty4;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty5")
    private BigDecimal cbatchproperty5;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty6")
    private String cbatchproperty6;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty7")
    private String cbatchproperty7;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty8")
    private String cbatchproperty8;

    /**  */
    @Excel(name = "")
    @Column(name="cbatchproperty9")
    private String cbatchproperty9;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="cbatchproperty10")
    private Date cbatchproperty10;

    /**  */
    @Excel(name = "")
    @Column(name="dblpreexchmomey")
    private BigDecimal dblpreexchmomey;

    /**  */
    @Excel(name = "")
    @Column(name="dblpremomey")
    private BigDecimal dblpremomey;

    /**  */
    @Excel(name = "")
    @Column(name="idemandtype")
    private Integer idemandtype;

    /**  */
    @Excel(name = "")
    @Column(name="cdemandcode")
    private String cdemandcode;

    /**  */
    @Excel(name = "")
    @Column(name="cdemandmemo")
    private String cdemandmemo;

    /**  */
    @Excel(name = "")
    @Column(name="cdemandid")
    private String cdemandid;

    /**  */
    @Excel(name = "")
    @Column(name="idemandseq")
    private Long idemandseq;

    /**  */
    @Excel(name = "")
    @Column(name="cvencode")
    private String cvencode;

    /**  */
    @Excel(name = "")
    @Column(name="creasoncode")
    private String creasoncode;

    /**  */
    @Excel(name = "")
    @Column(name="cinvsn")
    private String cinvsn;

    /**  */
    @Excel(name = "")
    @Column(name="iinvsncount")
    private Integer iinvsncount;

    /**  */
    @Excel(name = "")
    @Column(name="bneedsign")
    private Integer bneedsign;

    /**  */
    @Excel(name = "")
    @Column(name="bsignover")
    private Integer bsignover;

    /**  */
    @Excel(name = "")
    @Column(name="bneedloss")
    private Integer bneedloss;

    /**  */
    @Excel(name = "")
    @Column(name="flossrate")
    private BigDecimal flossrate;

    /**  */
    @Excel(name = "")
    @Column(name="frlossqty")
    private BigDecimal frlossqty;

    /**  */
    @Excel(name = "")
    @Column(name="fulossqty")
    private BigDecimal fulossqty;

    /**  */
    @Excel(name = "")
    @Column(name="isettletype")
    private Integer isettletype;

    /**  */
    @Excel(name = "")
    @Column(name="crelacuscode")
    private String crelacuscode;

    /**  */
    @Excel(name = "")
    @Column(name="clossmaker")
    private String clossmaker;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dlossdate")
    private Date dlossdate;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dlosstime")
    private Date dlosstime;

    /**  */
    @Excel(name = "")
    @Column(name="icoridlsid")
    private Long icoridlsid;

    /**  */
    @Excel(name = "")
    @Column(name="fretoutqty")
    private BigDecimal fretoutqty;

    /**  */
    @Excel(name = "")
    @Column(name="body_outid")
    private String bodyOutid;

    /**  */
    @Excel(name = "")
    @Column(name="fveribillqty")
    private BigDecimal fveribillqty;

    /**  */
    @Excel(name = "")
    @Column(name="fveribillsum")
    private BigDecimal fveribillsum;

    /**  */
    @Excel(name = "")
    @Column(name="fveriretqty")
    private BigDecimal fveriretqty;

    /**  */
    @Excel(name = "")
    @Column(name="fveriretsum")
    private BigDecimal fveriretsum;

    /**  */
    @Excel(name = "")
    @Column(name="flastsettleqty")
    private BigDecimal flastsettleqty;

    /**  */
    @Excel(name = "")
    @Column(name="flastsettlesum")
    private BigDecimal flastsettlesum;

    /**  */
    @Excel(name = "")
    @Column(name="cbookwhcode")
    private String cbookwhcode;

    /**  */
    @Excel(name = "")
    @Column(name="cinvouchtype")
    private String cinvouchtype;

    /**  */
    @Excel(name = "")
    @Column(name="cposition")
    private String cposition;

    /**  */
    @Excel(name = "")
    @Column(name="fretqtywkp")
    private BigDecimal fretqtywkp;

    /**  */
    @Excel(name = "")
    @Column(name="fretqtyykp")
    private BigDecimal fretqtyykp;

    /**  */
    @Excel(name = "")
    @Column(name="frettbqtyykp")
    private BigDecimal frettbqtyykp;

    /**  */
    @Excel(name = "")
    @Column(name="fretsumykp")
    private BigDecimal fretsumykp;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dkeepdate")
    private Date dkeepdate;

    /**  */
    @Excel(name = "")
    @Column(name="cscloser")
    private String cscloser;

    /**  */
    @Excel(name = "")
    @Column(name="isaleoutid")
    private Long isaleoutid;

    /**  */
    @Excel(name = "")
    @Column(name="bsaleprice")
    private Integer bsaleprice=1;

    /**  */
    @Excel(name = "")
    @Column(name="bgift")
    private Integer bgift=0;

    /**  */
    @Excel(name = "")
    @Column(name="bmpforderclosed")
    private Integer bmpforderclosed;

    /**  */
    @Excel(name = "")
    @Column(name="cbsysbarcode")
    private String cbsysbarcode;

    /**  */
    @Excel(name = "")
    @Column(name="fxjquantity")
    private BigDecimal fxjquantity;

    /**  */
    @Excel(name = "")
    @Column(name="fxjnum")
    private BigDecimal fxjnum;

    /**  */
    @Excel(name = "")
    @Column(name="biacreatebill")
    private Integer biacreatebill;

    /**  */
    @Excel(name = "")
    @Column(name="cparentcode")
    private String cparentcode;

    /**  */
    @Excel(name = "")
    @Column(name="cchildcode")
    private String cchildcode;

    /**  */
    @Excel(name = "")
    @Column(name="fchildqty")
    private BigDecimal fchildqty;

    /**  */
    @Excel(name = "")
    @Column(name="fchildrate")
    private BigDecimal fchildrate;

    /**  */
    @Excel(name = "")
    @Column(name="icalctype")
    private Integer icalctype;

    /**  */
    @Excel(name = "")
    @Column(name="fappretwkpqty")
    private BigDecimal fappretwkpqty;

    /**  */
    @Excel(name = "")
    @Column(name="fappretwkpsum")
    private BigDecimal fappretwkpsum;

    /**  */
    @Excel(name = "")
    @Column(name="fappretykpqty")
    private BigDecimal fappretykpqty;

    /**  */
    @Excel(name = "")
    @Column(name="fappretykpsum")
    private BigDecimal fappretykpsum;

    /**  */
    @Excel(name = "")
    @Column(name="fappretwkptbqty")
    private BigDecimal fappretwkptbqty;

    /**  */
    @Excel(name = "")
    @Column(name="fappretykptbqty")
    private BigDecimal fappretykptbqty;

    /**  */
    @Excel(name = "")
    @Column(name="irtnappid")
    private Long irtnappid;

    /**  */
    @Excel(name = "")
    @Column(name="crtnappcode")
    private String crtnappcode;

    /**  */
    @Excel(name = "")
    @Column(name="fretailrealamount")
    private BigDecimal fretailrealamount;

    /**  */
    @Excel(name = "")
    @Column(name="fretailsettleamount")
    private BigDecimal fretailsettleamount;

    /**  */
    @Excel(name = "")
    @Column(name="cfactorycode")
    private String cfactorycode;

    /**  */
    @Excel(name = "")
    @Column(name="gcsourceid")
    private Integer gcsourceid;

    /**  */
    @Excel(name = "")
    @Column(name="gcsourceids")
    private Integer gcsourceids;

    /**  */
    @Excel(name = "")
    @Column(name="cconfirmer")
    private String cconfirmer;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dconfirmdate")
    private Date dconfirmdate;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dsclosedate")
    private Date dsclosedate;

    /**  */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "", width = 30, dateFormat = "yyyy-MM-dd")
    @Column(name="dsclosesystime")
    private Date dsclosesystime;


}
